{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>job</th>\n",
       "      <th>company</th>\n",
       "      <th>city</th>\n",
       "      <th>salary_min</th>\n",
       "      <th>salary_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>金融数据分析师/助理</td>\n",
       "      <td>华壹信融投资管理（北京）有限责任...</td>\n",
       "      <td>北京</td>\n",
       "      <td>8333.33</td>\n",
       "      <td>12500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a（0经验可培养）金融数据分析师/助理</td>\n",
       "      <td>深圳市中创荣投资有限公司</td>\n",
       "      <td>深圳</td>\n",
       "      <td>8000.00</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>初级运营数据分析专员 助理</td>\n",
       "      <td>知才（上海）信息技术有限公司</td>\n",
       "      <td>上海</td>\n",
       "      <td>6000.00</td>\n",
       "      <td>8000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>销售数据分析</td>\n",
       "      <td>上海品星互联网信息技术有限公司</td>\n",
       "      <td>北京</td>\n",
       "      <td>5000.00</td>\n",
       "      <td>9000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>数据分析经理</td>\n",
       "      <td>美菜网</td>\n",
       "      <td>上海</td>\n",
       "      <td>13000.00</td>\n",
       "      <td>17000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   job              company city  salary_min  salary_max\n",
       "0           金融数据分析师/助理  华壹信融投资管理（北京）有限责任...   北京     8333.33     12500.0\n",
       "1  a（0经验可培养）金融数据分析师/助理         深圳市中创荣投资有限公司   深圳     8000.00     10000.0\n",
       "2        初级运营数据分析专员 助理       知才（上海）信息技术有限公司   上海     6000.00      8000.0\n",
       "3               销售数据分析      上海品星互联网信息技术有限公司   北京     5000.00      9000.0\n",
       "4               数据分析经理                  美菜网   上海    13000.00     17000.0"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "file = \"jobs_51_info (1).csv\"\n",
    "jobs = pd.read_csv(file, header=0)\n",
    "# 信息预览\n",
    "jobs.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['北京', '深圳', '上海', '武汉', '广州', '南京', '西安', '杭州', '成都', '苏州', nan],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jobs[\"city\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10329.230455194938"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jobs[jobs[\"city\"]==\"北京\"][\"salary_min\"].mean(skipna=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "广州    15634\n",
       "深圳    14448\n",
       "上海    13027\n",
       "北京     5093\n",
       "杭州     4615\n",
       "武汉     3682\n",
       "成都     2811\n",
       "南京     2165\n",
       "苏州     1486\n",
       "西安     1329\n",
       "Name: city, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jobs[\"city\"].value_counts()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>job</th>\n",
       "      <th>company</th>\n",
       "      <th>city</th>\n",
       "      <th>salary_min</th>\n",
       "      <th>salary_max</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>金融数据分析师/助理</td>\n",
       "      <td>华壹信融投资管理（北京）有限责任...</td>\n",
       "      <td>北京</td>\n",
       "      <td>8333.33</td>\n",
       "      <td>12500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a（0经验可培养）金融数据分析师/助理</td>\n",
       "      <td>深圳市中创荣投资有限公司</td>\n",
       "      <td>深圳</td>\n",
       "      <td>8000.00</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>初级运营数据分析专员 助理</td>\n",
       "      <td>知才（上海）信息技术有限公司</td>\n",
       "      <td>上海</td>\n",
       "      <td>6000.00</td>\n",
       "      <td>8000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>销售数据分析</td>\n",
       "      <td>上海品星互联网信息技术有限公司</td>\n",
       "      <td>北京</td>\n",
       "      <td>5000.00</td>\n",
       "      <td>9000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>数据分析经理</td>\n",
       "      <td>美菜网</td>\n",
       "      <td>上海</td>\n",
       "      <td>13000.00</td>\n",
       "      <td>17000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66761</th>\n",
       "      <td>运营支持岗</td>\n",
       "      <td>九州通医药集团物流有限公司</td>\n",
       "      <td>武汉</td>\n",
       "      <td>3000.00</td>\n",
       "      <td>5000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66762</th>\n",
       "      <td>新媒体运营专员</td>\n",
       "      <td>深圳市摩天之星企业管理有限公司龙...</td>\n",
       "      <td>深圳</td>\n",
       "      <td>8000.00</td>\n",
       "      <td>10000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66763</th>\n",
       "      <td>电商运营总监</td>\n",
       "      <td>福建特家商业管理有限公司</td>\n",
       "      <td>广州</td>\n",
       "      <td>20000.00</td>\n",
       "      <td>30000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66764</th>\n",
       "      <td>总经理/CEO</td>\n",
       "      <td>福建特家商业管理有限公司</td>\n",
       "      <td>广州</td>\n",
       "      <td>30000.00</td>\n",
       "      <td>50000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66765</th>\n",
       "      <td>会员商城运营管理师</td>\n",
       "      <td>统一企业（中国）投资有限公司</td>\n",
       "      <td>上海</td>\n",
       "      <td>8000.00</td>\n",
       "      <td>16000.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63017 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       job              company city  salary_min  salary_max\n",
       "0               金融数据分析师/助理  华壹信融投资管理（北京）有限责任...   北京     8333.33     12500.0\n",
       "1      a（0经验可培养）金融数据分析师/助理         深圳市中创荣投资有限公司   深圳     8000.00     10000.0\n",
       "2            初级运营数据分析专员 助理       知才（上海）信息技术有限公司   上海     6000.00      8000.0\n",
       "3                   销售数据分析      上海品星互联网信息技术有限公司   北京     5000.00      9000.0\n",
       "4                   数据分析经理                  美菜网   上海    13000.00     17000.0\n",
       "...                    ...                  ...  ...         ...         ...\n",
       "66761                运营支持岗        九州通医药集团物流有限公司   武汉     3000.00      5000.0\n",
       "66762              新媒体运营专员  深圳市摩天之星企业管理有限公司龙...   深圳     8000.00     10000.0\n",
       "66763               电商运营总监         福建特家商业管理有限公司   广州    20000.00     30000.0\n",
       "66764              总经理/CEO         福建特家商业管理有限公司   广州    30000.00     50000.0\n",
       "66765            会员商城运营管理师       统一企业（中国）投资有限公司   上海     8000.00     16000.0\n",
       "\n",
       "[63017 rows x 5 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "jobs.dropna(axis=0)"
   ]
  }
 ],
 "metadata": {
  "interpreter": {
   "hash": "ac59ebe37160ed0dfa835113d9b8498d9f09ceb179beaac4002f036b9467c963"
  },
  "kernelspec": {
   "display_name": "Python 3.9.0 64-bit",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.0"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
